/**
 * 
 */
package com.pentalog.fullsix.dialect;

import org.hibernate.dialect.MySQL5InnoDBDialect;
import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.dialect.function.StandardSQLFunction;
import org.hibernate.type.StandardBasicTypes;

/**
 * @author tlehuu Apr 24, 2012
 */
public class GinetDialect extends MySQL5InnoDBDialect {
	public GinetDialect() {
		super();
		registerFunction( "concat", new SQLFunctionTemplate(StandardBasicTypes.STRING, "concat(?1, ?2)") );
		registerFunction("lcase", new StandardSQLFunction("lcase") );
		registerFunction("group_concat_distinct", new SQLFunctionTemplate(StandardBasicTypes.STRING, "group_concat(distinct ?1)"));
//		registerFunction("group_concat", new StandardSQLFunction("group_concat", StandardBasicTypes.STRING));
	}
}
